/*
 Navicat MySQL Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : 127.0.0.1:3306
 Source Schema         : yuyue

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 28/12/2023 10:32:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yzn_admin
-- ----------------------------
DROP TABLE IF EXISTS `yzn_admin`;
CREATE TABLE `yzn_admin` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '管理账号',
  `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '管理密码',
  `roleid` tinyint unsigned DEFAULT '0',
  `encrypt` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '加密因子',
  `nickname` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称',
  `last_login_time` int unsigned DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
  `email` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Session标识',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表';

-- ----------------------------
-- Records of yzn_admin
-- ----------------------------
BEGIN;
INSERT INTO `yzn_admin` VALUES (1, 'admin', 'f63ff9fc00be18de27c8f61278f420b1', 1, '596f87', '御宅男', 1702976570, '172.19.0.1', 'admin@admin.com', 'fb1bce34-daed-4780-ba83-f00e6de16ed6', 1);
COMMIT;

-- ----------------------------
-- Table structure for yzn_adminlog
-- ----------------------------
DROP TABLE IF EXISTS `yzn_adminlog`;
CREATE TABLE `yzn_adminlog` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  `uid` smallint NOT NULL DEFAULT '0' COMMENT '操作者ID',
  `info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '说明',
  `create_time` int unsigned NOT NULL DEFAULT '0',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作IP',
  `get` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=224 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志';

-- ----------------------------
-- Records of yzn_adminlog
-- ----------------------------
BEGIN;
INSERT INTO `yzn_adminlog` VALUES (1, 0, 0, '提示语:请先登陆', 1696753582, '172.19.0.1', '/admin/');
INSERT INTO `yzn_adminlog` VALUES (2, 1, 1, '提示语:恭喜您，登陆成功', 1696753597, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (3, 0, 1, '提示语:令牌错误！', 1696753836, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (4, 1, 1, '提示语:新增成功', 1696753849, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (5, 0, 1, '提示语:令牌错误！', 1696753959, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (6, 1, 1, '提示语:新增成功', 1696753960, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (7, 0, 1, '提示语:参数不能为空', 1696755940, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (8, 0, 1, '提示语:参数不能为空', 1696756001, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (9, 0, 1, '提示语:用户名不能为空', 1696756062, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (10, 0, 1, '提示语:真实姓名只能是字母、数字和下划线_及破折号-', 1696756290, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (11, 0, 1, '提示语:真实姓名长度不符合要求 3,20', 1696756339, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (12, 0, 1, '提示语:密码和确认字段不一致', 1696756351, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (13, 0, 1, '提示语:密码和确认字段不一致', 1696756484, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (14, 0, 1, '提示语:SQLSTATE[HY000]: General error: 1364 Field \'info\' doesn\'t have a default value', 1696756488, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (15, 0, 1, '提示语:SQLSTATE[HY000]: General error: 1364 Field \'info\' doesn\'t have a default value', 1696756556, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (16, 0, 1, '提示语:SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: \'1696756578\' for column \'create_time\' at row 1', 1696756578, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (17, 1, 1, '提示语:添加成功！', 1696756602, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (18, 1, 1, '提示语:操作成功！', 1696757022, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (19, 1, 1, '提示语:操作成功！', 1696757029, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (20, 1, 1, '提示语:操作成功！', 1696757078, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (21, 1, 1, '提示语:操作成功！', 1696757089, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (22, 1, 1, '提示语:操作成功！', 1696757131, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (23, 1, 1, '提示语:操作成功！', 1696757132, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (24, 0, 1, '提示语:参数不能为空', 1696757479, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (25, 0, 1, '提示语:参数不能为空', 1696757490, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (26, 1, 1, '提示语:修改成功！', 1696757649, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (27, 1, 1, '提示语:新增成功', 1696757696, '172.19.0.1', '/admin/auth.rule/add.html?parentid=51&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (28, 1, 1, '提示语:新增成功', 1696757718, '172.19.0.1', '/admin/auth.rule/add.html?parentid=51&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (29, 1, 1, '提示语:新增成功', 1696757731, '172.19.0.1', '/admin/auth.rule/add.html?parentid=51&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (30, 1, 1, '提示语:操作成功！', 1696757766, '172.19.0.1', '/admin/staff.index/del.html?id=1');
INSERT INTO `yzn_adminlog` VALUES (31, 1, 1, '提示语:添加成功！', 1696757793, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (32, 1, 1, '提示语:新增成功', 1696758195, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (33, 1, 1, '提示语:新增成功', 1696758224, '172.19.0.1', '/admin/auth.rule/add.html?parentid=55&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (34, 0, 1, '提示语:真实姓名已存在', 1696758891, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (35, 0, 1, '提示语:区域名称已存在', 1696758918, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (36, 0, 1, '提示语:区域总库存规则错误', 1696758952, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (37, 1, 1, '提示语:添加成功！', 1696758960, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (38, 1, 1, '提示语:添加成功！', 1696758981, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (39, 1, 1, '提示语:操作成功！', 1696759111, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (40, 1, 1, '提示语:操作成功！', 1696759111, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (41, 1, 1, '提示语:操作成功！', 1696759112, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (42, 0, 1, '提示语:手机号不能为空', 1696759186, '172.19.0.1', '/admin/area.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (43, 1, 1, '提示语:修改成功！', 1696759210, '172.19.0.1', '/admin/area.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (44, 1, 1, '提示语:操作成功！', 1696759383, '172.19.0.1', '/admin/area.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (45, 1, 1, '提示语:操作成功！', 1696759384, '172.19.0.1', '/admin/area.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (46, 1, 1, '提示语:操作成功！', 1696759385, '172.19.0.1', '/admin/area.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (47, 1, 1, '提示语:操作成功！', 1696759388, '172.19.0.1', '/admin/area.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (48, 1, 1, '提示语:新增成功', 1696772728, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (49, 1, 1, '提示语:新增成功', 1696772750, '172.19.0.1', '/admin/auth.rule/add.html?parentid=57&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (50, 1, 1, '提示语:新增成功', 1696772778, '172.19.0.1', '/admin/auth.rule/add.html?parentid=56&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (51, 1, 1, '提示语:编辑成功', 1696772800, '172.19.0.1', '/admin/auth.rule/edit.html?id=57&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (52, 0, 1, '提示语:区域名称不能为空', 1696775469, '172.19.0.1', '/admin/car.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (53, 1, 1, '提示语:添加成功！', 1696775551, '172.19.0.1', '/admin/car.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (54, 1, 1, '提示语:操作成功！', 1696776115, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (55, 1, 1, '提示语:操作成功！', 1696776116, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (56, 1, 1, '提示语:操作成功！', 1696776116, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (57, 1, 1, '提示语:操作成功！', 1696776117, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (58, 1, 1, '提示语:操作成功！', 1696776118, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (59, 1, 1, '提示语:操作成功！', 1696776123, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (60, 1, 1, '提示语:操作成功！', 1696776132, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (61, 1, 1, '提示语:操作成功！', 1696776210, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (62, 1, 1, '提示语:操作成功！', 1696776241, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (63, 1, 1, '提示语:操作成功！', 1696776274, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (64, 1, 1, '提示语:操作成功！', 1696776277, '172.19.0.1', '/admin/car.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (65, 1, 1, '提示语:操作成功！', 1696776314, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (66, 1, 1, '提示语:操作成功！', 1696776339, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (67, 1, 1, '提示语:操作成功！', 1696776342, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (68, 1, 1, '提示语:操作成功！', 1696778145, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (69, 1, 1, '提示语:操作成功！', 1696778146, '172.19.0.1', '/admin/staff.index/multi.html');
INSERT INTO `yzn_adminlog` VALUES (70, 0, 0, '提示语:请先登陆', 1696778662, '172.19.0.1', '/admin/');
INSERT INTO `yzn_adminlog` VALUES (71, 1, 1, '提示语:恭喜您，登陆成功', 1696778672, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (72, 1, 0, '提示语:注销成功！', 1696778738, '172.19.0.1', '/admin/index/logout.html');
INSERT INTO `yzn_adminlog` VALUES (73, 1, 1, '提示语:恭喜您，登陆成功', 1696778746, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (74, 1, 1, '提示语:修改成功！', 1696778754, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (75, 1, 1, '提示语:修改成功！', 1696778760, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (76, 0, 0, '提示语:请先登陆', 1696778837, '172.19.0.1', '/admin/');
INSERT INTO `yzn_adminlog` VALUES (77, 1, 1, '提示语:恭喜您，登陆成功', 1696778851, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (78, 1, 1, '提示语:修改成功！', 1696778865, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (79, 0, 0, '提示语:请先登陆', 1696779162, '172.19.0.1', '/admin/');
INSERT INTO `yzn_adminlog` VALUES (80, 1, 1, '提示语:恭喜您，登陆成功', 1696779170, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (81, 1, 1, '提示语:修改成功！', 1696779178, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (82, 0, 1, '提示语:区域名称不能为空', 1696779187, '172.19.0.1', '/admin/car.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (83, 0, 1, '提示语:车辆编号已存在', 1696779207, '172.19.0.1', '/admin/car.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (84, 1, 1, '提示语:修改成功！', 1696779213, '172.19.0.1', '/admin/car.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (85, 1, 1, '提示语:修改成功！', 1696779220, '172.19.0.1', '/admin/car.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (86, 0, 0, '提示语:请先登陆', 1696779459, '172.19.0.1', '/admin/index/index.html');
INSERT INTO `yzn_adminlog` VALUES (87, 1, 1, '提示语:恭喜您，登陆成功', 1696779468, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (88, 1, 1, '提示语:修改成功！', 1696779551, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (89, 1, 1, '提示语:修改成功！', 1696780072, '172.19.0.1', '/admin/car.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (90, 1, 1, '提示语:清理缓存', 1696814284, '172.19.0.1', '/admin/index/cache.html?type=all&_=1696813764457');
INSERT INTO `yzn_adminlog` VALUES (91, 1, 0, '提示语:注销成功！', 1696831090, '172.19.0.1', '/admin/index/logout.html');
INSERT INTO `yzn_adminlog` VALUES (92, 1, 1, '提示语:恭喜您，登陆成功', 1696831111, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (93, 1, 0, '提示语:注销成功！', 1696831146, '172.19.0.1', '/admin/index/logout.html');
INSERT INTO `yzn_adminlog` VALUES (94, 0, 0, '提示语:验证码错误!', 1696831160, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (95, 1, 1, '提示语:恭喜您，登陆成功', 1696831170, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (96, 0, 0, '提示语:请先登陆', 1696927653, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (97, 1, 1, '提示语:恭喜您，登陆成功', 1696927670, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (98, 0, 0, '提示语:请先登陆', 1698146884, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (99, 1, 1, '提示语:恭喜您，登陆成功', 1698146893, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (100, 0, 0, '提示语:请先登陆', 1698150192, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (101, 0, 0, '提示语:请先登陆', 1698150735, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (102, 1, 1, '提示语:设置更新成功', 1698204082, '172.19.0.1', '/admin/general.config/setting/group/system.html');
INSERT INTO `yzn_adminlog` VALUES (103, 1, 1, '提示语:新增成功', 1698204202, '172.19.0.1', '/admin/general.config/add/groupType/system.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (104, 1, 1, '提示语:新增成功', 1698204225, '172.19.0.1', '/admin/general.config/add/groupType/system.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (105, 1, 1, '提示语:编辑成功', 1698204289, '172.19.0.1', '/admin/general.config/edit.html?id=16&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (106, 1, 1, '提示语:编辑成功', 1698204300, '172.19.0.1', '/admin/general.config/edit.html?id=15&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (107, 1, 1, '提示语:编辑成功', 1698204384, '172.19.0.1', '/admin/general.config/edit.html?id=16&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (108, 1, 1, '提示语:编辑成功', 1698204390, '172.19.0.1', '/admin/general.config/edit.html?id=15&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (109, 1, 1, '提示语:设置更新成功', 1698204421, '172.19.0.1', '/admin/general.config/setting/group/system.html');
INSERT INTO `yzn_adminlog` VALUES (110, 1, 1, '提示语:修改成功！', 1698219964, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (111, 1, 1, '提示语:修改成功！', 1698219970, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (112, 1, 1, '提示语:修改成功！', 1698220004, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (113, 1, 1, '提示语:修改成功！', 1698220012, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (114, 0, 1, '提示语:真实姓名已存在', 1698220208, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (115, 1, 1, '提示语:添加成功！', 1698220215, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (116, 1, 1, '提示语:修改成功！', 1698220260, '172.19.0.1', '/admin/staff.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (117, 0, 1, '提示语:区域已存在', 1698220298, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (118, 0, 1, '提示语:区域已存在', 1698220309, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (119, 0, 1, '提示语:该区域管理员已存在', 1698220321, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (120, 0, 1, '提示语:该区域管理员已存在', 1698220328, '172.19.0.1', '/admin/staff.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (121, 1, 1, '提示语:新增成功', 1698220742, '172.19.0.1', '/admin/auth.rule/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (122, 1, 1, '提示语:新增成功', 1698220766, '172.19.0.1', '/admin/auth.rule/add.html?parentid=60&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (123, 1, 1, '提示语:清理缓存', 1698221005, '172.19.0.1', '/admin/index/cache.html?type=data&_=1698220997052');
INSERT INTO `yzn_adminlog` VALUES (124, 0, 0, '提示语:请先登陆', 1698240188, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (125, 1, 1, '提示语:恭喜您，登陆成功', 1698240196, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (126, 0, 1, '提示语:SQLSTATE[HY000]: General error: 1364 Field \'stock\' doesn\'t have a default value', 1698240216, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (127, 1, 1, '提示语:添加成功！', 1698240364, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (128, 1, 1, '提示语:添加成功！', 1698240378, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (129, 1, 1, '提示语:添加成功！', 1698240388, '172.19.0.1', '/admin/area.index/add.html?dialog=1');
INSERT INTO `yzn_adminlog` VALUES (130, 1, 1, '提示语:修改成功！', 1698240743, '172.19.0.1', '/admin/area.index/edit.html?id=6&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (131, 1, 1, '提示语:修改成功！', 1698240752, '172.19.0.1', '/admin/area.index/edit.html?id=5&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (132, 1, 1, '提示语:修改成功！', 1698240759, '172.19.0.1', '/admin/area.index/edit.html?id=4&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (133, 1, 1, '提示语:修改成功！', 1698240764, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (134, 1, 1, '提示语:修改成功！', 1698240770, '172.19.0.1', '/admin/area.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (135, 1, 1, '提示语:修改成功！', 1698246276, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (136, 0, 0, '提示语:请先登陆', 1698674215, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (137, 0, 0, '提示语:验证码错误!', 1698674240, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (138, 1, 1, '提示语:恭喜您，登陆成功', 1698674251, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (139, 0, 0, '提示语:请先登陆', 1699163083, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (140, 0, 0, '提示语:验证码错误!', 1699163093, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (141, 1, 1, '提示语:恭喜您，登陆成功', 1699163097, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (142, 0, 1, '提示语:手机号已存在', 1699163217, '172.19.0.1', '/admin/staff.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (143, 0, 0, '提示语:请先登陆', 1699238400, '172.19.0.1', '/admin');
INSERT INTO `yzn_adminlog` VALUES (144, 1, 1, '提示语:恭喜您，登陆成功', 1699238408, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (145, 1, 1, '提示语:修改成功！', 1699238424, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (146, 0, 1, '提示语:该区域管理员已存在', 1699253197, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (147, 1, 1, '提示语:修改成功！', 1699253203, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (148, 1, 1, '提示语:修改成功！', 1699253210, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (149, 1, 1, '提示语:修改成功！', 1699257370, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (150, 1, 1, '提示语:修改成功！', 1699286832, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (151, 1, 1, '提示语:修改成功！', 1699286859, '172.19.0.1', '/admin/area.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (152, 1, 1, '提示语:修改成功！', 1699286998, '172.19.0.1', '/admin/area.index/edit.html?id=3&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (153, 1, 1, '提示语:修改成功！', 1699287062, '172.19.0.1', '/admin/area.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (154, 1, 1, '提示语:修改成功！', 1699347555, '172.19.0.1', '/admin/car.index/edit.html?id=4&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (155, 1, 1, '提示语:修改成功！', 1699347589, '172.19.0.1', '/admin/car.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (156, 1, 1, '提示语:操作成功！', 1699347651, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (157, 1, 1, '提示语:操作成功！', 1699347700, '172.19.0.1', '/admin/auth.rule/multi.html');
INSERT INTO `yzn_adminlog` VALUES (158, 1, 1, '提示语:设置更新成功', 1699347730, '172.19.0.1', '/admin/general.config/setting/group/system.html');
INSERT INTO `yzn_adminlog` VALUES (159, 1, 1, '提示语:设置更新成功', 1699347752, '172.19.0.1', '/admin/general.config/setting/group/system.html');
INSERT INTO `yzn_adminlog` VALUES (160, 0, 1, '提示语:配置名称已存在', 1699347883, '172.19.0.1', '/admin/general.config/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (161, 1, 1, '提示语:操作成功！', 1699347908, '172.19.0.1', '/admin/general.config/del.html?id=16');
INSERT INTO `yzn_adminlog` VALUES (162, 1, 1, '提示语:操作成功！', 1699347911, '172.19.0.1', '/admin/general.config/del.html?id=1');
INSERT INTO `yzn_adminlog` VALUES (163, 1, 1, '提示语:操作成功！', 1699347946, '172.19.0.1', '/admin/general.config/del.html?id=2');
INSERT INTO `yzn_adminlog` VALUES (164, 1, 1, '提示语:编辑成功', 1699348017, '172.19.0.1', '/admin/general.config/edit.html?id=15&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (165, 1, 1, '提示语:修改成功！', 1699348990, '172.19.0.1', '/admin/area.index/edit.html?id=6&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (166, 1, 1, '提示语:修改成功！', 1699349005, '172.19.0.1', '/admin/area.index/edit.html?id=6&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (167, 1, 1, '提示语:修改成功！', 1699349017, '172.19.0.1', '/admin/area.index/edit.html?id=6&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (168, 1, 1, '提示语:修改成功！', 1699349150, '172.19.0.1', '/admin/area.index/edit.html?id=5&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (169, 1, 1, '提示语:修改成功！', 1699349203, '172.19.0.1', '/admin/area.index/edit.html?id=5&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (170, 1, 1, '提示语:修改成功！', 1699349218, '172.19.0.1', '/admin/area.index/edit.html?id=5&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (171, 1, 1, '提示语:修改成功！', 1699349335, '172.19.0.1', '/admin/area.index/edit.html?id=5&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (172, 0, 0, '提示语:请先登陆', 1702976556, '172.19.0.1', '/admin/index/index.html');
INSERT INTO `yzn_adminlog` VALUES (173, 1, 1, '提示语:恭喜您，登陆成功', 1702976570, '172.19.0.1', '/admin/index/login.html');
INSERT INTO `yzn_adminlog` VALUES (174, 0, 1, '提示语:该页面不存在！', 1702976667, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (175, 0, 1, '提示语:该页面不存在！', 1702976676, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (176, 0, 1, '提示语:该页面不存在！', 1702977377, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (177, 0, 1, '提示语:该页面不存在！', 1702978282, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (178, 1, 1, '提示语:编辑成功', 1703052843, '172.19.0.1', '/admin/general.config/edit.html?id=16&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (179, 0, 1, '提示语:该区域管理员已存在', 1703053148, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (180, 1, 1, '提示语:修改成功！', 1703053195, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (181, 1, 1, '提示语:修改成功！', 1703053203, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (182, 1, 1, '提示语:修改成功！', 1703053211, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (183, 1, 1, '提示语:修改成功！', 1703053220, '172.19.0.1', '/admin/staff.index/edit.html?id=2&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (184, 1, 1, '提示语:修改成功！', 1703053225, '172.19.0.1', '/admin/staff.index/edit.html?id=1&dialog=1');
INSERT INTO `yzn_adminlog` VALUES (185, 0, 1, '提示语:该页面不存在！', 1703053288, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (186, 0, 1, '提示语:该页面不存在！', 1703053331, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (187, 0, 1, '提示语:该页面不存在！', 1703053335, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (188, 0, 1, '提示语:该页面不存在！', 1703053370, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (189, 0, 1, '提示语:该页面不存在！', 1703053380, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (190, 0, 1, '提示语:该页面不存在！', 1703053495, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (191, 0, 1, '提示语:该页面不存在！', 1703053545, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (192, 0, 1, '提示语:该页面不存在！', 1703053590, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (193, 0, 1, '提示语:该页面不存在！', 1703053671, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (194, 0, 1, '提示语:该页面不存在！', 1703053695, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (195, 0, 1, '提示语:该页面不存在！', 1703053725, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (196, 0, 1, '提示语:该页面不存在！', 1703053748, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (197, 0, 1, '提示语:该页面不存在！', 1703053761, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (198, 0, 1, '提示语:该页面不存在！', 1703053870, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (199, 0, 1, '提示语:该页面不存在！', 1703053892, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (200, 0, 1, '提示语:该页面不存在！', 1703053902, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (201, 0, 1, '提示语:该页面不存在！', 1703053922, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (202, 0, 1, '提示语:该页面不存在！', 1703053928, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (203, 0, 1, '提示语:该页面不存在！', 1703053942, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (204, 0, 1, '提示语:该页面不存在！', 1703053943, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (205, 0, 1, '提示语:该页面不存在！', 1703053944, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (206, 0, 1, '提示语:该页面不存在！', 1703053944, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (207, 0, 1, '提示语:该页面不存在！', 1703053945, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (208, 0, 1, '提示语:该页面不存在！', 1703053946, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (209, 0, 1, '提示语:该页面不存在！', 1703053946, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (210, 0, 1, '提示语:该页面不存在！', 1703054035, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (211, 0, 1, '提示语:该页面不存在！', 1703054037, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (212, 0, 1, '提示语:该页面不存在！', 1703054041, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (213, 0, 1, '提示语:该页面不存在！', 1703054085, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (214, 0, 1, '提示语:该页面不存在！', 1703054087, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (215, 0, 1, '提示语:该页面不存在！', 1703054140, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (216, 0, 1, '提示语:该页面不存在！', 1703054170, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (217, 0, 1, '提示语:该页面不存在！', 1703054324, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (218, 0, 1, '提示语:该页面不存在！', 1703054372, '172.19.0.1', '/admin/index/getArea');
INSERT INTO `yzn_adminlog` VALUES (219, 0, 1, '提示语:未知参数', 1703058693, '172.19.0.1', '/admin/order.index/del.html?id=35');
INSERT INTO `yzn_adminlog` VALUES (220, 1, 1, '提示语:操作成功！', 1703058735, '172.19.0.1', '/admin/order.index/del.html?id=35');
INSERT INTO `yzn_adminlog` VALUES (221, 1, 1, '提示语:操作成功！', 1703058741, '172.19.0.1', '/admin/order.index/del.html?id=34');
INSERT INTO `yzn_adminlog` VALUES (222, 1, 1, '提示语:操作成功！', 1703058742, '172.19.0.1', '/admin/order.index/del.html?id=33');
INSERT INTO `yzn_adminlog` VALUES (223, 1, 1, '提示语:操作成功！', 1703058745, '172.19.0.1', '/admin/order.index/del.html?id=32');
COMMIT;

-- ----------------------------
-- Table structure for yzn_area
-- ----------------------------
DROP TABLE IF EXISTS `yzn_area`;
CREATE TABLE `yzn_area` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '停车区名称',
  `num` int NOT NULL COMMENT '库存',
  `stock` int NOT NULL DEFAULT '50' COMMENT '剩余库存',
  `status` tinyint DEFAULT '1' COMMENT '状态 1正常 0关闭',
  `create_time` int DEFAULT NULL,
  `sort` tinyint DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of yzn_area
-- ----------------------------
BEGIN;
INSERT INTO `yzn_area` VALUES (2, 'B区', 100, 100, 1, 1696758981, 40);
INSERT INTO `yzn_area` VALUES (3, 'A区', 50, 50, 1, 1696758960, 50);
INSERT INTO `yzn_area` VALUES (4, 'C区', 20, 20, 1, 1698240364, 30);
INSERT INTO `yzn_area` VALUES (5, 'D区', 18, 18, 1, 1698240378, 20);
INSERT INTO `yzn_area` VALUES (6, 'E区', 40, 40, 0, 1698240388, 10);
COMMIT;

-- ----------------------------
-- Table structure for yzn_attachment
-- ----------------------------
DROP TABLE IF EXISTS `yzn_attachment`;
CREATE TABLE `yzn_attachment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `aid` smallint unsigned NOT NULL DEFAULT '0' COMMENT '管理员id',
  `uid` mediumint unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
  `module` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模块名，由哪个模块上传的',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件路径',
  `thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '缩略图路径',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件链接',
  `mime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `ext` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件类型',
  `size` int unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'sha1 散列值',
  `driver` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local' COMMENT '上传驱动',
  `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorders` int NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='附件表';

-- ----------------------------
-- Table structure for yzn_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `yzn_auth_group`;
CREATE TABLE `yzn_auth_group` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `parentid` mediumint unsigned NOT NULL DEFAULT '0' COMMENT '父组别',
  `title` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述信息',
  `rules` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限组表';

-- ----------------------------
-- Records of yzn_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `yzn_auth_group` VALUES (1, 0, '超级管理员', '拥有所有权限', '*', 1);
INSERT INTO `yzn_auth_group` VALUES (2, 1, '编辑', '编辑', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for yzn_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `yzn_auth_rule`;
CREATE TABLE `yzn_auth_rule` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `parentid` int unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图标',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则URL',
  `condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '条件',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `ismenu` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `menutype` enum('_iframe','_blank','_layer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单类型',
  `extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展属性',
  `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorder` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `parentid` (`parentid`),
  KEY `listorder` (`listorder`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='节点表';

-- ----------------------------
-- Records of yzn_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `yzn_auth_rule` VALUES (1, 0, 'general', '常规管理', 'iconfont icon-setup', '', '', '', 1, NULL, '', 1691377129, 1696757029, 999, 1);
INSERT INTO `yzn_auth_rule` VALUES (2, 0, 'addons', '插件管理', 'iconfont icon-equalizer-line', '', '', '', 1, NULL, '', 1691377129, 1699347651, 777, 0);
INSERT INTO `yzn_auth_rule` VALUES (4, 1, 'general.profile', '个人资料', 'iconfont icon-user-line', '', '', '', 1, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (5, 4, 'general.profile/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (6, 4, 'general.profile/update', '资料更新', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (10, 1, 'general.config', '配置管理', 'iconfont icon-apartment', '', '', '', 1, NULL, '', 1691377129, 1691377129, 999, 1);
INSERT INTO `yzn_auth_rule` VALUES (11, 1, 'general.config/setting', '网站设置', 'iconfont icon-setup', '', '', '', 1, NULL, '', 1691377129, 1691377129, 888, 1);
INSERT INTO `yzn_auth_rule` VALUES (12, 28, 'auth.rule', '菜单管理', 'iconfont icon-other', '', '', '', 1, NULL, '', 1691377129, 1691377129, 666, 1);
INSERT INTO `yzn_auth_rule` VALUES (13, 1, 'general.attachments', '附件管理', 'iconfont icon-accessory', '', '', '', 1, NULL, '', 1691377129, 1699347700, 666, 0);
INSERT INTO `yzn_auth_rule` VALUES (14, 13, 'general.attachments/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (15, 13, 'general.attachments/del', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (16, 13, 'general.attachments/getUrlFile', '图片本地化', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (17, 13, 'general.attachments/select', '图片选择', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (18, 12, 'auth.rule/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (19, 12, 'auth.rule/add', '新增', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (20, 12, 'auth.rule/edit', '编辑', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (21, 12, 'auth.rule/del', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (22, 12, 'auth.rule/multi', '批量更新', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (23, 10, 'general.config/add', '新增', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (24, 10, 'general.config/edit', '编辑', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (25, 10, 'general.config/del', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (26, 10, 'general.config/multi', '批量更新', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (27, 10, 'general.config/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (28, 0, 'auth', '权限管理', 'iconfont icon-user-settings-line', '', '', '', 1, NULL, '', 1691377129, 1691377129, 888, 1);
INSERT INTO `yzn_auth_rule` VALUES (29, 28, 'auth.manager', '管理员管理', 'iconfont icon-user-settings-line', '', '', '', 1, NULL, '', 1691377129, 1691377129, 999, 1);
INSERT INTO `yzn_auth_rule` VALUES (30, 29, 'auth.manager/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (31, 29, 'auth.manager/edit', '编辑', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (32, 29, 'auth.manager/del', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (33, 29, 'auth.manager/add', '新增', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (34, 28, 'auth.adminlog', '管理日志', 'iconfont icon-history', '', '', '', 1, NULL, '', 1691377129, 1691377129, 888, 1);
INSERT INTO `yzn_auth_rule` VALUES (35, 34, 'auth.adminlog/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (36, 34, 'auth.adminlog/deletelog', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (37, 28, 'auth.group', '角色管理', 'iconfont icon-user-shared-2-line', '', '', '', 1, NULL, '', 1691377129, 1691377129, 777, 1);
INSERT INTO `yzn_auth_rule` VALUES (38, 37, 'auth.group/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (39, 37, 'auth.group/add', '新增', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (40, 37, 'auth.group/edit', '编辑', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (41, 37, 'auth.group/del', '删除', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (42, 37, 'auth.group/access', '访问授权', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (45, 2, 'addons/index', '查看', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (46, 2, 'addons/config', '配置', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (49, 2, 'addons/state', '禁用启用', '', '', '', '', 0, NULL, '', 1691377129, 1691377129, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (50, 0, 'staff', '员工管理', 'iconfont icon-user-fill', '', '', '', 1, '_iframe', '', 1696753849, 1696753849, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (51, 50, 'staff.index', '员工列表', '', '', '', '', 1, '_iframe', '', 1696753960, 1696753960, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (52, 51, 'staff.index/index', '查看', '', '', '', '', 1, '_iframe', '', 1696757696, 1696759111, 0, 0);
INSERT INTO `yzn_auth_rule` VALUES (53, 51, 'staff.index/add', '新增', '', '', '', '', 1, '_iframe', '', 1696757718, 1696759111, 0, 0);
INSERT INTO `yzn_auth_rule` VALUES (54, 51, 'staff.index/edit', '编辑', '', '', '', '', 1, '_iframe', '', 1696757730, 1696759112, 0, 0);
INSERT INTO `yzn_auth_rule` VALUES (55, 0, 'area', '停车区管理', 'iconfont icon-map-fill', '', '', '', 1, '_iframe', '', 1696758195, 1696758195, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (56, 55, 'area.index', '停车区列表', '', '', '', '', 1, '_iframe', '', 1696758224, 1696776339, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (57, 0, 'car', '车辆管理', 'iconfont icon-riding-fill', '', '', '', 1, '_iframe', '', 1696772728, 1696772800, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (58, 57, 'car.index', '车辆列表', '', '', '', '', 1, '_iframe', '', 1696772750, 1696772750, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (59, 56, 'area.add', '添加', '', '', '', '', 1, '_iframe', '', 1696772778, 1696776342, 0, 0);
INSERT INTO `yzn_auth_rule` VALUES (60, 0, 'order', '预约管理', 'iconfont icon-history', '', '', '', 1, '_iframe', '', 1698220742, 1698220742, 0, 1);
INSERT INTO `yzn_auth_rule` VALUES (61, 60, 'order.index', '预约列表', '', '', '', '', 1, '_iframe', '', 1698220766, 1698220766, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for yzn_cache
-- ----------------------------
DROP TABLE IF EXISTS `yzn_cache`;
CREATE TABLE `yzn_cache` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '缓存KEY值',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `module` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模块名称',
  `model` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模型名称',
  `action` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '方法名',
  `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否系统',
  PRIMARY KEY (`id`),
  KEY `ckey` (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='缓存列队表';

-- ----------------------------
-- Records of yzn_cache
-- ----------------------------
BEGIN;
INSERT INTO `yzn_cache` VALUES (1, 'Model', '模型列表', 'admin', 'Models', 'model_cache', 1);
INSERT INTO `yzn_cache` VALUES (2, 'ModelField', '模型字段', 'admin', 'ModelField', 'model_field_cache', 1);
COMMIT;

-- ----------------------------
-- Table structure for yzn_car
-- ----------------------------
DROP TABLE IF EXISTS `yzn_car`;
CREATE TABLE `yzn_car` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `aid` int NOT NULL COMMENT '所属区域',
  `number` varchar(100) NOT NULL,
  `create_time` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of yzn_car
-- ----------------------------
BEGIN;
INSERT INTO `yzn_car` VALUES (1, 5, '4589882MEW', 1696775551, 1);
INSERT INTO `yzn_car` VALUES (2, 3, '4589882MEWQ', 1696775551, 1);
INSERT INTO `yzn_car` VALUES (3, 2, '458982MEW', 1696775551, 1);
INSERT INTO `yzn_car` VALUES (4, 4, '45882MEW', 1696775551, 1);
COMMIT;

-- ----------------------------
-- Table structure for yzn_config
-- ----------------------------
DROP TABLE IF EXISTS `yzn_config`;
CREATE TABLE `yzn_config` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置类型',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置说明',
  `group` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置分组',
  `options` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置项',
  `remark` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text COLLATE utf8mb4_unicode_ci COMMENT '配置值',
  `visible` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '可见条件',
  `listorder` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`),
  KEY `group` (`group`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网站配置';

-- ----------------------------
-- Records of yzn_config
-- ----------------------------
BEGIN;
INSERT INTO `yzn_config` VALUES (16, 'web_make_car', 'number', '车辆使用时长', 'base', '', '车辆使用时长，配置为n/小时', 1698204225, 1703052843, 1, '2', '', 100);
INSERT INTO `yzn_config` VALUES (3, 'config_group', 'array', '配置分组', 'system', '', '', 1494408414, 1494408414, 1, '{\"system\":\"系统\"}', '', 0);
INSERT INTO `yzn_config` VALUES (4, 'theme', 'text', '主题风格', 'system', '', '', 1541752781, 1541756888, 1, 'default', '', 1);
INSERT INTO `yzn_config` VALUES (5, 'admin_forbid_ip', 'textarea', '后台禁止访问IP', 'system', '', '匹配IP段用\"*\"占位，如192.168.*.*，多个IP地址请用英文逗号\",\"分割', 1551244957, 1551244957, 1, '', '', 2);
INSERT INTO `yzn_config` VALUES (6, 'upload_image_size', 'text', '图片上传大小限制', 'upload', '', '0为不限制大小，单位：kb', 1540457656, 1552436075, 1, '0', '', 2);
INSERT INTO `yzn_config` VALUES (7, 'upload_image_ext', 'text', '允许上传图片后缀', 'upload', '', '多个后缀用逗号隔开，不填写则不限制类型', 1540457657, 1552436074, 1, 'gif,jpg,jpeg,bmp,png', '', 1);
INSERT INTO `yzn_config` VALUES (8, 'upload_file_size', 'text', '文件上传大小限制', 'upload', '', '0为不限制大小，单位：kb', 1540457658, 1552436078, 1, '0', '', 3);
INSERT INTO `yzn_config` VALUES (9, 'upload_file_ext', 'text', '允许上传文件后缀', 'upload', '', '多个后缀用逗号隔开，不填写则不限制类型', 1540457659, 1552436080, 1, 'doc,docx,xls,xlsx,ppt,pptx,pdf,wps,txt,rar,zip,gz,bz2,7z', '', 4);
INSERT INTO `yzn_config` VALUES (10, 'upload_driver', 'radio', '上传驱动', 'upload', 'local:本地', '图片或文件上传驱动', 1541752781, 1552436085, 1, 'local', '', 9);
INSERT INTO `yzn_config` VALUES (11, 'upload_thumb_water', 'switch', '添加水印', 'upload', '', '', 1552435063, 1552436080, 1, '0', '', 5);
INSERT INTO `yzn_config` VALUES (12, 'upload_thumb_water_pic', 'image', '水印图片', 'upload', '', '只有开启水印功能才生效', 1552435183, 1552436081, 1, '', '', 6);
INSERT INTO `yzn_config` VALUES (13, 'upload_thumb_water_position', 'radio', '水印位置', 'upload', '1:左上角\r\n2:上居中\r\n3:右上角\r\n4:左居中\r\n5:居中\r\n6:右居中\r\n7:左下角\r\n8:下居中\r\n9:右下角', '只有开启水印功能才生效', 1552435257, 1552436082, 1, '9', '', 7);
INSERT INTO `yzn_config` VALUES (14, 'upload_thumb_water_alpha', 'text', '水印透明度', 'upload', '', '请输入0~100之间的数字，数字越小，透明度越高', 1552435299, 1552436083, 1, '50', '', 8);
INSERT INTO `yzn_config` VALUES (15, 'web_close_order', 'number', '预约自动取消时间', 'base', '', '预约超时未取车自动取消时间，配置为n/分钟', 1698204202, 1699348017, 1, '2', '', 100);
COMMIT;

-- ----------------------------
-- Table structure for yzn_ems
-- ----------------------------
DROP TABLE IF EXISTS `yzn_ems`;
CREATE TABLE `yzn_ems` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '事件',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '验证码',
  `times` int unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作IP',
  `create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱验证码表';

-- ----------------------------
-- Table structure for yzn_field_type
-- ----------------------------
DROP TABLE IF EXISTS `yzn_field_type`;
CREATE TABLE `yzn_field_type` (
  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段类型',
  `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '中文类型名',
  `listorder` int NOT NULL DEFAULT '0' COMMENT '排序',
  `default_define` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '默认定义',
  `ifoption` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否需要设置选项',
  `ifstring` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否自由字符',
  PRIMARY KEY (`name`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='字段类型表';

-- ----------------------------
-- Records of yzn_field_type
-- ----------------------------
BEGIN;
INSERT INTO `yzn_field_type` VALUES ('text', '输入框', 1, 'varchar(255) NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('checkbox', '复选框', 2, 'varchar(32) NOT NULL', 1, 0);
INSERT INTO `yzn_field_type` VALUES ('textarea', '多行文本', 3, 'varchar(255) NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('password', '密码', 4, 'varchar(255) NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('radio', '单选按钮', 5, 'char(10) NOT NULL', 1, 0);
INSERT INTO `yzn_field_type` VALUES ('switch', '开关', 6, 'tinyint(2) UNSIGNED NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('array', '数组', 7, 'varchar(512) NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('select', '下拉框', 8, 'char(10) NOT NULL', 1, 0);
INSERT INTO `yzn_field_type` VALUES ('selects', '下拉框(多选)', 9, 'varchar(32) NOT NULL', 1, 0);
INSERT INTO `yzn_field_type` VALUES ('selectpage', '高级下拉框', 10, 'varchar(32) NOT NULL', 1, 0);
INSERT INTO `yzn_field_type` VALUES ('image', '单张图', 11, 'varchar(255) NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('images', '多张图', 12, 'text NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('tags', '标签', 13, 'varchar(255) NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('number', '数字', 14, 'int(10) UNSIGNED NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('datetime', '日期和时间', 15, 'int(10) UNSIGNED NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('Ueditor', '百度编辑器', 16, 'mediumtext NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('markdown', 'markdown编辑器', 17, 'mediumtext NOT NULL', 0, 1);
INSERT INTO `yzn_field_type` VALUES ('files', '多文件', 18, 'text NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('file', '单文件', 19, 'varchar(255) NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('color', '颜色值', 20, 'varchar(7) NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('city', '城市地区', 21, 'varchar(255) NOT NULL', 0, 0);
INSERT INTO `yzn_field_type` VALUES ('custom', '自定义', 22, 'text NOT NULL', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for yzn_model
-- ----------------------------
DROP TABLE IF EXISTS `yzn_model`;
CREATE TABLE `yzn_model` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '所属模块',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模型名称',
  `tablename` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表名',
  `description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  `setting` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置信息',
  `type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '模型类别：1-独立表，2-主附表',
  `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorders` tinyint NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='模型列表';

-- ----------------------------
-- Table structure for yzn_model_field
-- ----------------------------
DROP TABLE IF EXISTS `yzn_model_field`;
CREATE TABLE `yzn_model_field` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `modelid` smallint unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
  `name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字段名',
  `title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '别名',
  `remark` tinytext COLLATE utf8mb4_unicode_ci COMMENT '字段提示',
  `pattern` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据校验正则',
  `errortips` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据校验未通过的提示信息',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字段类型',
  `setting` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '字段配置',
  `ifsystem` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '是否主表字段 1 是',
  `iscore` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否内部字段',
  `iffixed` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否固定不可修改',
  `ifrequire` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否必填',
  `ifsearch` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '作为搜索条件',
  `isadd` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '在投稿中显示',
  `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorder` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `name` (`name`,`modelid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='模型字段列表';

-- ----------------------------
-- Table structure for yzn_order
-- ----------------------------
DROP TABLE IF EXISTS `yzn_order`;
CREATE TABLE `yzn_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `aid` int NOT NULL COMMENT '厂区',
  `uid` int NOT NULL COMMENT '用户ID',
  `carId` int NOT NULL COMMENT '车辆ID',
  `makeTime` int NOT NULL COMMENT '预约时间',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0:已预约。1:使用中，2:已归还，3:已取消,4:超时自动取消',
  `returnTime` int DEFAULT NULL COMMENT '归还时间',
  `qrcode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '二维码',
  `createTime` int NOT NULL COMMENT '创建时间',
  `updateTime` int NOT NULL,
  `adminId` int DEFAULT NULL COMMENT '管理员ID',
  `getCarTime` int DEFAULT NULL,
  `returnCarTime` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of yzn_order
-- ----------------------------
BEGIN;
INSERT INTO `yzn_order` VALUES (36, 3, 1, 2, 1703296855, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAL3klEQVR4nO3dIXMa2x+HcfKffwwIEMFgqACDwaA3qoIKTGtTcyNiyDtoRHgHIBqRmtS2JoKI1gSNicGAyBoMFUEQg8gVnbnTmXtn+dKezfJtn48+czjZ7NMg+puz9/T0lAPg6X9ZHwDAzyNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMOHtKlPXpnCQ/yZ/T7/fFT6/Vavq2tVot+I/fbrf1AwT/9N9Y8pPkLzBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8b+H2qj8/PzVqsVarcdMR6Pz87Osj6FZD6fv3r1Sl8srjw5Oel0OsrKcrks7rkV3qtkwQJutVrtdjvUbtjW4+Pjzc1N8G0bjUa2v1beq2R8hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGAs2zKC7u7sbjUbP/7n/iKKo2WxmeIDr6+s4jpWVt7e34p6lUuno6Ehc/PHjx4eHh7AHqFar4txSSv7Q9yrUJVTD4VC82Eq/sCsl/X5fPOpwONS3Ffd8enpKY7zmd73cjPcqeSu+QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjGUwjYRKpSKOEyyXy8VikfZ5EpTL5WKxqKysVCppHwb/RsAZuLy8FFcOBoPT09NUD5Ps3bt33W43wwMgGV+hAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwxjTSTjs6OhIvUprP5/V6Xdz2w4cP4vTf+/fvxW0PDw/1KSuEQsA7rVQqlUolcfFsNhNX6gPJ6/Va3Fb/5wMB8RUaMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGAsg2GGKIr6/f7zf+6PB8jw01NycHCgP9WDg4NUD5OJP/O9yiDgZrPZbDaf/3N/b6VS6Q+/hezPfK/4Cg0YI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMBZsmGE8Hofaanek9EONx+PFYqGsrFarjUZDWfn4+Hh7eyse4PDwMJ/Pi4uzxXu1wVOiYB/zB0h+kj8S7yvL5XLdblfcczqd6kedTqfitvqEU7vd1p+AflQkP0m+QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYGzDOCGDI9kaDAaDwUBZWavV9F9WvV6fzWa/cK5fxXsVCn+BAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwtmEa6dWrV89zjv9UqVQuLy/FxcfHx/P5PNXzhJLGhV3z+Vz/ZekP6uTkpNPpKCvjOE7jbTk/P2+1WsG31envlf6sQtrlS6i+j8iJarVatqf9LfX7ffH5D4fDNA4wHA71dyAN+nulP6uA+AoNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDC2YRqp2+0G/8i7u7vRaBR827dv3y4WC2XlaDS6u7tTVlarVX2+RLzEKJfLdTqdarUqLs5Ws9kUV1arVf1t0Z9VGh4eHj5+/Cgu7nQ66/VaWak/q5Cef36i3++LZ9tqGkmnv2ftdlvfVn/mmU/YZC7bZzWdTvUDTKfT4AcIiK/QgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjG6aRdPP5/PHxUVkpzgxtK45jcWpkf39fvC+jWCzOZjPxAPodHMvlUt9WtL+/n8aE02KxWC6Xysp8Pl+pVMRt9WdVKBTElQ8PD9++fVNW3t/fi3um5PHxUb+easOzCjUV0W63A/xk/zq6foA07rDZ6r4fo2elS2lyKw36lNtW0phGCvhe8RUaMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjwcYJ0xDHcb1eFxd/+PBBHGd7//69uG2r1dLv0dGP2uv1go/O7O/vh93wu3fv3p2enior8/m8vu1Wv9YoipSVR0dH4pjX/f39y5cvxQPoer3e1dWVsnKr9yrZTge8Xq/1udlKpSJOFOrb1ut1fUpRP2qxWNS3zVa5XC6Xy8G31Z/VarUSV5ZKpVKp9LMnCmCxWKTxXiXjKzRgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwNiGYQZxEiWXy00mk18+zM6ZTCb6E9BdXFzc3NwoKw8PD1+/fh38ALrPnz/f3t4qKxuNxsnJSdrnSTAajT59+qSsFK9r+67X6xWLRWVluVwWh8xWq5X+Xm3YM/nqJPEzdoF+CZV+YVfmut2u+EOlJKXLzfQnMBwOxT1TutxMl8mleXyFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwY2zCNJF42swv0u3kajUa2P9d4PF4sFsrKOI7FuaWUFAoF8VlVq1X9qPrz15/AarUSt12tVqPRSDxAFEWFQkHcVjxqHMfB3kBxfgIBGf2zmMmEzc89K31ya6uLxdKYcttqcisZX6EBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDC2YZxwb2/vec7xG3hK4SqpbrcrXvkzm83q9XrwA6Qk2/eqVqvpv6x6vT6bzcIe4ObmRn8CyUflLzBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8Y2TCPpzs/PW61WqN12xHg8Pjs7y/AA19fX4ihMsVjUbyc6Pj6ez+fKyouLC/HCLvG6tu/0o56dnY3HY2Wl/qy20uv1isWisvLi4uL6+jr4ATZIvjpJ32c4HIa6r2l3ZH5hl+77iJyoVqsFP8BWsn1WW0njcrOtJH8oX6EBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8aCTSPp7u7uRqPR83/uP6IoajabGR7AiP6s4jjWZ3EGg4G4Mo5jcWWz2YyiSFysu76+3t/fV1aWSqWU5hmSJM866Pvo00jibV3p6ff74lGZRkrpWaWh2+3qTyDbZxUQX6EBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YymEZCpVIR/4v8crkU7xxar9f6zUCVSkVcKV4LlMvlCoWC/v/+tzpqPp9XVpbLZXHP3wkBZ+Dy8lJcORgMTk9PlZVxHNfrdXHb6XQa/HqkKIqm06m4eG9vT1x5eXmZ+fVIu4yv0IAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGGMaKQPHx8e3t7fKyk6nI4743N/fv3z58tfO9R96vd7V1ZWy8vDwUJ+y0ueW9MnHq6urXq+nrHzx4sWXL1/Ebb9+/bper5WVBwcH4p6j0eivv/4SFyc/KwLOwHw+Fwdi1+t18Lm/rSwWC/Go+jBjLpdL44daLpf6mLGuWq0G33O1WoU6Kl+hAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGMhhmiKKo3+8//+f+eIAMP93LmzdvxCmFrf7Tv3jhUy6XOzk5aTQaykr9vdJvbMvlcr1eT7xf7s2bN8//amUQcLPZbDabz/+5+AlRFKXxUg4GA3Flu90WA07pvbq6utLnsZ4/YL5CA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMBRtmGI/HobbaHZn/UHEc39zcKCuXy2W73Ra3zefz4srJZBLHsbKyXC63Wi1x2zTEcTyZTJSVhUIhjamDyWQi/rJCvldPiYJ9zB8g+Un+SC9NV6vV9APout2ueIB2u61vq/9cw+FQ3FOfUd3qWWV7N1Vu03vFV2jAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBoztbTUaAmCn8BcYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMPY3rQCNcTGctEcAAAAASUVORK5CYII=', 1703210464, 1703212202, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (37, 3, 2, 2, 1703297592, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703211193, 1703212043, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (41, 3, 2, 2, 1703311405, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703225007, 1703225014, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (42, 3, 2, 2, 1703311606, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703225207, 1703225213, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (43, 3, 2, 2, 1703312076, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703225678, 1703225686, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (44, 3, 2, 2, 1703312108, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703225711, 1703225723, 1, NULL, NULL);
INSERT INTO `yzn_order` VALUES (45, 3, 2, 2, 1703485286, 3, NULL, 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALzklEQVR4nO3dIVMb3QLG8XDnxoAggpiYrUhMzJroRFUsAoVtTStiwjcAQb7BRhQBBmxrIoIoBnRMTUwiuiYmFUSAQXBFZ97pnXtn86Tssjzw/+kzJycn+3/Zd6Znzsbj42MJgKd/Fb0AAH+PgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMODsMVXRq3OSvpN/J45j8dPr9bo+bb1ez/zrR1GkLyDzT3/F0neSv8CAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBj7d1YTHR8ft1qtrGZ7Icbj8dHRUdGrkMzn893dXX2wOLLb7e7t7Skjq9WqOOdaeK7SZRZwq9WKoiir2bCu+/v7y8vLzKdtNpvF/qw8V+l4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMIPux48fNzc3z/+5/2i322EYFriA4XCYJIky8vr6WpyzUql8+PBBHHxxcXF7e5vtAoIgEM8t5eSNPldZXUI1Go3Ei630C7tyEsexuNTRaKRPK875+PiYx/Ga13q5Gc9V+lS8QgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBVwGgm1Wk08TrBcLheLRd7rSVGtVre3t5WRtVot78XgfxFwAU5PT8WRg8Hg4OAg18WkOzw87PV6BS4A6XiFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGKeRXrQPHz6IFynN5/NGoyFOe3Z2Jp7++/Llizhtp9PRT1khKwT8olUqlUqlIg6ezWbiSP1A8sPDgzit/p8PZIhXaMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGCBgwRsCAsQIOM7Tb7TiOn/9z/1xAgZ+ek52dHX1Xd3Z2cl1MId7mc1VAwGEYhmH4/J/7ulUqlTd+C9nbfK54hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvsMMN4PM5qqpcjpy81Ho8Xi4UyMgiCZrOpjLy/v7++vhYX0Ol0Njc3xcHF4rla4TFVZh/zBqTv5J/E+8pKpVKv1xPnnE6n+lKn06k4rX7CKYoifQf0pSJ9J3mFBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DA2IrjhBwcKdZgMBgMBsrIer2u/1iNRmM2mz1hXU/Fc5UV/gIDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGBsxWmk3d3d51nH/1Wr1U5PT8XBnz9/ns/nua4nK3lc2DWfz/UfS9+obre7t7enjEySJI+n5fj4uNVqZT6tTn+u9L3K0ku+hOr3ETlRvV4vdrWvUhzH4v6PRqM8FjAajfRnIA/6c6XvVYZ4hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxGqnX64kTDYfDJEmUkWEYttttZWS5XBZvBiqVSnt7ew8PD+LgYuWxVzkJw1AcGQSB/rToP2sebm9vLy4uxMH6c6XvVZayOhURRZH4ib1eT5xzOp3qX2Q6nWb1XfKWx1550X/WPE4jvabnildowBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwICxFaeRZrOZONH29rZ4CUW1WhXnXMvPnz/zmDYP+l6Vy2X9J9AFQVAul5WRi8ViuVwqIzc3N2u1mrgA/b6Sra0tceTt7e2vX7+UkYU/Kvf39/r1VCv2Kv2sg76mwk+NGNH3Ko7jPBagn7DRTwhGUfS3v3M2Ct8r3Vr3SKVPxSs0YIyAAWMEDBgjYMAYAQPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPGNh5TjxzpZ9kODw/H47Ey8uPHj4eHh8rI2WzWaDTEBegODw8/fvyY+bRrLUDcq+VyuVgsMl/AdDoVD/TldJxQ/1nPzs7E693WOk74/v17cQH6XvX7/fPzc2Vkq9Xq9/viAtI/fcV5YP3c5nK5FGvP44lcS7Va1b9XHvS9Kly1Ws3j/Lb+9e/u7sSRlUqlUqn87YoysFgsxO/VaDSyegJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGFtxmEHX7XajKFJG3t7eHhwcKCPL5bJ+4U2/38/8mMRkMjk5OREH60vV9yonOzs74shv375dX18rI5vNZrfbfcKinurm5ubr16/KyLWeK32v9vf3xVNWd3d3YgKllc9V5hc3raTvXb1e16fVj3fEcSzOmeElVKZyutxM39U8LoJb67nKA5ebASiV+H9gwBoBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2WkkXRAE4lkc/a6dUqnU6XTEsyBBEIhzVqvVPI4Njcdj8eBUEATNZlMZeX9/Lx4bWsvW1pa4A0EQXF5eitPqu5okiTjt3d2dOO329ra+1E6ns7m5qYycTCZJkigjkyTJ7Ll6nuMX+JP+4/V6PXHO6XSazQPx3wo/uVX4Xk2nU3HanE5upeMVGjBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYyuOE25sbDzPOl6Bx3Wu/BENBoPBYKCM/H3fjzhto9GYzWZPWNdTFftcFb5Xl5eX+g6kL5W/wIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGMvscrPj4+NWq5XVbC/EeDw+OjoqehWS+Xy+u7urDxZHnpyciPeAide1/aZfpHR0dDQej5WRw+EwjyNW/X5/e3tbGXlycjIcDjNfwArpVyfp84xGo6zua3o5Cr+w67Uy2qs8LjdbS/qH8goNGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDCW2Wkk3Y8fP25ubp7/c//RbrfDMCxwAUb0vUqSRD+LI1749HtacWQYhu12WxysGw6H5XJZGVmpVHI6z5Am/ayDPo9+GimO4/y+jiKOY3GpnEbKaa/y0Ov19J9AV6/XxQXoe5UhXqEBYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YKOI2EWq0m/hP55XK51p1DoiAIxBM24rVApVJpa2tL/3f/+iVGtVptc3NTGVmtVsU5XxMCLsDp6ak4cjAYHBwcZL6Aq6srPTZRu92eTqfi4I2NDXHk6emp0eGt58crNGCMgAFjBAwYI2DAGAEDxggYMEbAgDECBowRMGCMgAFjBAwYI2DAGAEDxjiNVIDPnz9fX18rI/f29vQjProgCMSR/X7//PxcGdnpdPRTVvqXqtVq4sjz8/N+v6+MfPfu3ffv38Vpr66uHh4elJE7OzvinDc3N58+fRIHp+8VARdgPp+LB2IfHh4yP/e3lsViIS610Wjo0+bxpZbLpX7MWKf/x053d3eX1VJ5hQaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgjIABYwQMGCvgMEO73Y7j+Pk/988FFPjpXvb398VTCmv9o3/9wqdut9tsNpWR+nOl39hWKpX6/b54v9z+/v7zP1oFBByGYRiGz/+5+AvtdjuPh3IwGIgjoygSA87puTo/P9fPYz1/wLxCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMZXaYYTweZzXVy/Eqv9RaJpNJkiTKyGq12mq18l5PiiRJJpOJMnJrayuPUweTyeTy8lIZmeVz9Zgqs495A9J38k9RFIlz9no9fdo89Ho9calRFOnT6rs6Go3EOfUzqvV6XV9qsXdTlVY9V7xCA8YIGDBGwIAxAgaMETBgjIABYwQMGCNgwBgBA8YIGDBGwIAxAgaMETBgbGOtoyEAXhT+AgPGCBgwRsCAMQIGjBEwYIyAAWMEDBgjYMAYAQPG/gMFdlxowIrFBwAAAABJRU5ErkJggg==', 1703226092, 1703226655, 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for yzn_sms
-- ----------------------------
DROP TABLE IF EXISTS `yzn_sms`;
CREATE TABLE `yzn_sms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '事件',
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '验证码',
  `times` int unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作IP',
  `create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短信验证码表';

-- ----------------------------
-- Table structure for yzn_staff
-- ----------------------------
DROP TABLE IF EXISTS `yzn_staff`;
CREATE TABLE `yzn_staff` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '姓名',
  `phone` varchar(100) NOT NULL COMMENT '密码',
  `class` varchar(50) NOT NULL COMMENT '部门',
  `encrypt` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `password` varchar(255) NOT NULL COMMENT '密码',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态 0:冻结。1正常',
  `create_time` int NOT NULL COMMENT '创建时间',
  `identity` tinyint NOT NULL DEFAULT '0' COMMENT '0:员工。1:管理员',
  `aid` int NOT NULL COMMENT '管理员负责区域ID',
  `avatar` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of yzn_staff
-- ----------------------------
BEGIN;
INSERT INTO `yzn_staff` VALUES (1, '测试1', '18169401209', '管理员', 'Qn696U', '85cf186cdd4f641036a7e198f6eda226', 1, 1696757793, 1, 3, 'http://www.yuyue.com/uploads/20231220/59dd21b8be7f19b3fbe8d799ac917766.jpeg');
INSERT INTO `yzn_staff` VALUES (2, '测试', '18338787062', '技术', 'BDZy8o', 'a8cb2192936f6039aab78273e764b619', 1, 1696757793, 0, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for yzn_terms
-- ----------------------------
DROP TABLE IF EXISTS `yzn_terms`;
CREATE TABLE `yzn_terms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `parentid` smallint NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `module` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '所属模块',
  `setting` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '相关配置信息',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分类表';

-- ----------------------------
-- Table structure for yzn_user_token
-- ----------------------------
DROP TABLE IF EXISTS `yzn_user_token`;
CREATE TABLE `yzn_user_token` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Token',
  `user_id` int unsigned DEFAULT '0' COMMENT '会员ID',
  `act_type` tinyint DEFAULT '1' COMMENT '1：账号登录',
  `create_time` int DEFAULT NULL COMMENT '创建时间',
  `expire_time` int DEFAULT NULL COMMENT '过期时间',
  `last_time` int DEFAULT NULL COMMENT '最后时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb3 COMMENT='会员Token表';

-- ----------------------------
-- Records of yzn_user_token
-- ----------------------------
BEGIN;
INSERT INTO `yzn_user_token` VALUES (165, '1699333718494275codeforphp', 3, 1, 1698214274, 1699938518, 1699333718);
INSERT INTO `yzn_user_token` VALUES (166, '1703227430780479codeforphp', 2, 1, 1699250333, 1703832230, 1703227430);
INSERT INTO `yzn_user_token` VALUES (167, '1699334491525166codeforphp', 4, 1, 1699334491, 1699939291, 1699334491);
INSERT INTO `yzn_user_token` VALUES (171, '1703212054656723codeforphp', 1, 1, 1699336015, 1703816854, 1703212054);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
